package io.admin.modules.sys.dao;


import io.admin.modules.sys.entity.view.ViewNameValueEntity;
import io.admin.modules.sys.entity.view.ViewNameValueLotEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface ViewDao {



    //创新素质专业分析占比
    @Select("select * from ads_humanities_quality_speciality")
    List<ViewNameValueEntity> getView1();


    //道德素质最差的学院TOP10
    @Select("select * from ads_morality_college_top10")
    List<ViewNameValueEntity> getView2();

    //实践能力班级TOP10
    @Select("select * from ads_practice_class_top10")
    List<ViewNameValueEntity> getView3();

    //专业能力学院TOP10
    @Select("select * from ads_professional_quality_college_top10")
    List<ViewNameValueEntity> getView4();

    @Select("select * from ads_humanities_quality_speciality_physical_qualities")
    List<ViewNameValueLotEntity> getView5();

    @Select("select * from ads_speciality_score")
    List<ViewNameValueEntity> getView6();

    @Select("select * from ads_course_cx")
    List<ViewNameValueEntity> getView7();



    @Select("select * from ads_score_90_top10")
    List<ViewNameValueEntity> getView8();
}
